Interested to Buy Any Domain ? << Click Here >> for more details...
list the transformation used for the following:Heterogeneous
sources,Homogeneous sources,Find the 5 highest paid
employees with in a dept,create a summery table,generate
surrogate keys
- 2 Answers
- 7140 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagesh
For Heterogeneous sources,use joiner transformation
Homogeneous sources go for source qualifier transformation
TOP 5 SAL
SELECT ROWNUM,ENAME,SAL FROM (SELECT ENAME,SAL FROM EMP
ORDER BY SAL DESC)
Where rownum <6
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
how to load the data to fact table?
What is a staging area? What is the purpose of a staging area?
can be used COM component in Informatica ?
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
hoe to access second value in mapping parameter if it is having more than one value ?????????????
can cubes contain measures ?
Explain the key challenges that you face while performing etl testing.
what is an ETL or ETT? And what are the different types?
how do u set partition points in the mapping?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
