What are the challenges you have faced in your Project (DWH-
ETL)? Explain with example?
No Answer is Posted For this Question
Be the First to Post Answer
How You Pull the records on daily basis into your ETL Server.
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
What the difference is between a database, a data warehouse and a data mart?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
what is the command to get the list of files in a directory in unix?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
How will you update the row without using update statergy?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
What is a repository manager?