Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / giri
Tranformation is extract data from one data to another data base in condition,
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Differentiate between a repository server and a powerhouse?
what are 3 tech challenges/ common issues you face?
Have you worked with/created Parameter file
Difference between Target-based loading and constraint-based loading?
How can you validate all mappings in the repository simultaneously?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the different types of repositories created using informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is the need of an ETL tool?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Tell me about Propagate functions in informatica
Explain what transformation and how many are there in informatica?
