Home » Developer & Programmer » Data Integration » Datawarehousing
Datawarehousing [message #93206] Fri, 03 October 2003 03:15 Go to next message
Raj
Messages: 411
Registered: November 1998
Senior Member
State why, for the integration of multiple heterogeneous information sources, many industries prefer the update driven approach (which constructs and uses data warehouses), rather than the query driven approach (which applies integrators and wrappers). Describe situations where the query driven approach is preferable over the update driven approach
Re: Datawarehousing [message #93260 is a reply to message #93206] Fri, 05 March 2004 22:30 Go to previous messageGo to next message
srinivasa rao D
Messages: 1
Registered: March 2004
Junior Member
Can any one send me Informatica Realtime problems ,i will solve them and send to u.
Re: Datawarehousing [message #93426 is a reply to message #93260] Mon, 03 January 2005 20:09 Go to previous messageGo to next message
sri
Messages: 154
Registered: February 2000
Senior Member
what is the meaning of complex transformations and complex mapping plz give one example to that?
Re: Datawarehousing [message #93427 is a reply to message #93426] Mon, 03 January 2005 20:12 Go to previous messageGo to next message
sri
Messages: 154
Registered: February 2000
Senior Member
1. How do u change parameter when u move it from development to production.
2 How does the session recovery work
3. why use shortcuts(Instead of making copies)?
4. where is the reject loader
5. how do you use reject loader
6. do u have to change the reject file b4 using reject loader utility
7. Differences between version 4.7 and 5.1
8. Differences between version 5.1 and 1.7
9. Debugger – what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running
4. Mapplets – can you use an active transformation in a mapplet,
5. What are active transformations? Name them
6. Can u use flat files in Mapplets
7. How many transformations can be used in mapplets
8. Can a joiner be used in a mapplet?
9. What are active transformations
12. How can you join 3 tables? Why cant you use a single Joiner to join 3 tables
13. Global and Local shortcuts. Advantages.
16. Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can u use them in the mapping?
17. Have you worked with/created Parameter file
18. What’s the layout of parameter file (what does a parameter file contain?)?
19. Why do u use Mapping Parameter and mapping variable?
20. Where do u create/define mapping parameter and mapping variable?
22. Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
23. Slowly changing dimensions, types and where will you use them
24. What are the modules in Power Center
25. filter transformation in the condition one of the data is NULL would the record be dropped.

1) parameter&variable differences
2) reusable transformation & shortcut differences
3) mapplets ( can u use source qyalifier, can u use sequence generator, can u use target)
5) implementation methodology
6) do u have knowledge in ralph kimball methodology
7) according to his methodology what all u need before u build a datawarehouse
9) how do u recover rows from a failed session
11)sequence generator, when u move from develoment to production how will u reset
13)whats there in global repository
14)repository user profiles
15)how do u set a varible in incremental aggregation
16)can u create a flatfile target
17)what did u do in source pre load stored procedure
18)scheduling properties,whats the default (sequential)
19)in a concurrent batch if a session fails, can u start again from that session
20)when u move from devel to prod how will u retain a variable
21)partition, what happens if the specified key range is shorter n longer
22)performance tuning( what u did in performance tuning)
6.what are conformed dimensions?
7.what are factless facts? And in which scenario will you use such kinds of
fact tables.
8.can you avoid static cache in the lookup transformation? I mean can you
disable caching in a lookup transformation?
9.what is the meaning of complex transformation?
10.in any project how many mappings they will use(minimum)?

10• How do u implement unconn. Stored proc. In a mapping?
11• Can u access a repository created in previous version of Informatica?
12• What happens if the info. Server doesn’t find the session parameter in the parameter file?
31. How big was your fact table
32. How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
33. How will u convert rows into columns or columns into rows
4. What are the steps involved in the migration from older version to newer version of Informatica Server?
7. What are the main features of Oracle 8i with context to datawarehouse?
2. What are the new features of Power Center 5.0?
3. How to run a session, which contains mapplet?
4. Differentiate between Load Manager and DTM?
What are session parameters ? How do u set them ?
When do u use mapping parameters ? (In which transformations)
What is a parameter When and where do u them when does the value will be created
Desing time, run time . If u don’t create parameter what will happen
5. What are variable ports and list two situations when they can be used?
6. What are the parts of Informatica Server?
7. How does the server recognise the source and target databases.
Elaborate on this.
8. List the transformation used for the following:
a) Heterogeneous Sources
b) Homogeneous Sources
c) Find the 5 highest paid employees within a dept.
d) Create a Summary table
e) Generate surrogate keys
9. What is the difference between sequential batch and concurrent batch and which is recommended and why ?
14. A session S_MAP1 is in Repository A. While running the session error message has displayed
‘ server hot-ws270 is connect to Repository B ‘. What does it mean ?
15. How do you do error handling in Informatica ?
16. How do you implement scheduling in Informatica ?
17. What is the meaning of upgradation of repository ?
18. How can you run a session without using server manager ?
21. Consider two cases :
1. Power Center Server and Client on the same machine
2. Power Center Sever and Client on the different machines
What is the basic difference in these two setups and which is recommended?
22. Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
23. When you connect to repository for the first time it asks you for user name & password of repository and database both.
But subsequent times it asks only repository password. Why ?
24. What is the difference between normal and bulk loading.
Which one is recommended?
25. What is a test load ?
27. How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
28. What is the difference between a shortcut of an object and copy of an object?
Compare them.
29. What is mapplet and a reusable transformation?
30. How do you implement configuration management in Informatica?
31. What are Business Components in Informatica?
32. Dimension Object created in Oracle can be imported in Designer
33. Cubes contain measures
34. COM components can be used in Informatica
36. What is the advantage of persistent cache? When it should be used.
37. When will you use SQL override in a lookup transformation?
38. Two different admin users created for repository are ______ and_______
39. Two Default User groups created in the repository are ____ and ______
40. A mapping contains
• Source Table S_Time ( Start_Year, End_Year )
• Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
Stored procedure transformation : A procedure has two input parameters I_Start_Year, I_End_Year and output parameter as O_Date, Day , Month, Year, Quarter. If this session is running, how many rows will be available in the target and why ?
39. Two Sources S1, S2 containing measures M1,M2,M3, 4 Dimensions D1,D2,D3,D4,
1 Fact F1 containing measures M1, M2,M3 and Dimension Surrogate keys K1,K2,K3,K4
(a) Write a SQL statement to populate Fact table F1
(b) Design a mapping in Informatica for loading of Fact table F1.
40. What is the difference between connected lookup and unconnected lookup.
41. What is the difference between datacahe and lindex cahe.
42. When should one create a lookup transformation?
43. How do you handle performance issues in Informatica.Where can you monitor the performance ?
44. List and Discuss two approaches for updation of target table in informatica and
how they are different.
45. You have created a lookup tansformation for a certain condition which if true
returns multiple rows .When you go to the target and see only one row has come
and not all. Why is it so and how it can be corrected.
46. Where are the log files generally stored. Can you change the path of the file.
What can the path be?
47. Where is the cache (lookup, index) created and how can you see it.
Re: Datawarehousing [message #93444 is a reply to message #93426] Sun, 23 January 2005 04:07 Go to previous messageGo to next message
Sobers D'souza
Messages: 1
Registered: January 2005
Junior Member
What is Datawarehousing ?

What is signifigance ofDatawarehousing ?
Re: Datawarehousing [message #93450 is a reply to message #93427] Fri, 28 January 2005 00:32 Go to previous messageGo to next message
Pournima KAle
Messages: 2
Registered: January 2005
Junior Member
1. How do u change parameter when u move it from development to production.
Ans -
I don't think we need to change the parameter when we move from DEv to QA. It will automaticaly get copied when you upload mapping to QA server.
Re: Datawarehousing [message #93451 is a reply to message #93427] Fri, 28 January 2005 00:40 Go to previous messageGo to next message
Pournima KAle
Messages: 2
Registered: January 2005
Junior Member
45. You have created a lookup tansformation for a certain condition which if true
returns multiple rows .When you go to the target and see only one row has come
and not all. Why is it so and how it can be corrected.
Ans -
Yes, Lookup returns only one match row, you have 2 options in this, A. First match row. B. Last match row.

To get all the matching rows it is better to use joiner. Join the 2 tables on the matching condition and get all the rows.
Re: Datawarehousing [message #125947 is a reply to message #93426] Thu, 30 June 2005 01:37 Go to previous messageGo to next message
getin4raj
Messages: 1
Registered: June 2005
Location: chennai
Junior Member
can u send the complex mapping and complex transformation u had with example
Re: Datawarehousing [message #132130 is a reply to message #125947] Wed, 10 August 2005 23:20 Go to previous messageGo to next message
sidpaul
Messages: 3
Registered: August 2005
Location: chicago
Junior Member
would appreciate if someone could answer these questions
Re: Datawarehousing [message #180048 is a reply to message #93206] Thu, 29 June 2006 23:41 Go to previous messageGo to next message
coolbee_chinna
Messages: 7
Registered: June 2006
Junior Member
hi...
can u explain me a bit about retail warehousing domain like what r the dimensions present, what r the fact tables and aggregate tables to be created, what are the business rules to be applied, wht are the sources available and wht are the targets etc..
help appriciated.
and can anybody plz answer the above real time questions plz sothat, it will be a great help for us new guys..
cheers
chinna
Re: Informatica [message #180519 is a reply to message #93260] Tue, 04 July 2006 01:12 Go to previous messageGo to next message
learnetl
Messages: 2
Registered: June 2006
Location: mumbai
Junior Member
We have one existing mapping in our production environment. Now
we need to do some modification in mapping without changing the
logic,

We are going to do the following steps;

Execute the existing production mapping in the test environment
for testing by writing the output to flat files.

Execute the modified mapping in the test environment for testing
by writing the output to flat files.

Do we have any flat file comparison option in INFORMATICA? or
how to compare both flat files?


Thanks in Advance
Ramesh
Re: Datawarehousing [message #193683 is a reply to message #93260] Tue, 19 September 2006 00:06 Go to previous messageGo to next message
sunviks
Messages: 1
Registered: September 2006
Junior Member
Hi

I have a stored procedure(trunc_table) which is infact a package of various stored procedures with an input and an out put parameter. When I use it just to truncate the table it works well. But with a condition IIF(output!=0, abort('sp error')), it gives an error 0020: identifier sp_truc_tab must be declared. Any suggestions?

Thanks
Sunviks

[Updated on: Tue, 19 September 2006 00:19]

Report message to a moderator

Re: Datawarehousing [message #195179 is a reply to message #180048] Wed, 27 September 2006 05:42 Go to previous messageGo to next message
kamalakar.vura
Messages: 3
Registered: September 2006
Junior Member
in retail warehousing generally the facts and dimensions are datekey,product key,store key promotion key,product of sale transaction no,sales qty,sales amount,profit are the facts and dimensions are for date key:date key and its attributes,for product key:product key and its attributes and in the same manner for store and promotion
Re: Datawarehousing [message #206132 is a reply to message #93206] Tue, 28 November 2006 22:03 Go to previous messageGo to next message
amit.kothare
Messages: 1
Registered: November 2006
Junior Member
We need to work on 2 different version of the same object (mapping) of Informatica in a repository... Can this be acheived without hampering the common objects in the mappings ....

Thanks
Amit
Re: Datawarehousing [message #223477 is a reply to message #93260] Fri, 09 March 2007 02:03 Go to previous messageGo to next message
mad_bu
Messages: 8
Registered: August 2006
Junior Member
Hi,

Pls, Help me in solving this issue. I am new to Datawarehousing (informatica). I have a task in which I need to take a flat file as my source and use oracle's sequence generator for a column and store into target flat file with sequence numbers including.

EXample:
Source flat file
================
abc 1000
xyz 2000
def 3000

Target flat file
================
1 abc 1000
2 xyz 2000
3 def 3000

Note : The sequence numbers should come only from ORACLE (not from informatica's sequence generator Transformation).

I hope my question is clear...
Pls, Help me in solving this issue...

Thanks in Advance,
Mad.
Re: Datawarehousing [message #226409 is a reply to message #223477] Fri, 23 March 2007 10:09 Go to previous messageGo to next message
spinky
Messages: 21
Registered: March 2006
Junior Member
HI,

If you want a sequence to be generated from oracle, then better you create a stored procedure(eg:SEQ_PROC) which returns the ID generated though a sequence.In the Informatica Designer, while you create a Transformation..select the STORED PROCEDURE transformation, call the stored proc SEQ_PROC ,created above from this transformation.Link this to your required field in the Target.

Hope this helps to solve your problem..
Re: Datawarehousing [message #486703 is a reply to message #226409] Sun, 19 December 2010 04:18 Go to previous message
anilborru
Messages: 4
Registered: December 2010
Location: chennai
Junior Member
Hi,
U can use stored procedure or Expression.... so u can get answer
Previous Topic: Error table is not working in OWB ?
Next Topic: Informatica notes
Goto Forum:
  


Current Time: Thu Mar 28 07:19:47 CDT 2024