what is a transforamation?
Answers were Sorted based on User's Feedback
Answer / giri
Tranformation is extract data from one data to another data base in condition,
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / praveen.madishetty
A Transformation is a type of metadata object which is
responsible for transforming the data or processing the data
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / surya
When transfering the data from Source to Target,we used
multiple steps that steps in informatica is called as
transformations.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / swetha
It is a repostitory object that generates, modifies or
passes data.
| Is This Answer Correct ? | 0 Yes | 2 No |
What is depict expression change?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
can you avoid static cache in the lookup transformation? I mean can you
How to generate sequence numbers using expression transformation?
Explain the informatica workflow?
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
what are the real time problems generally come up while doing or running mapping or any transformation?
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
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.