what transformations are used for Variable port?
Answers were Sorted based on User's Feedback
Answer / murali krishna
We can use Variable port in the following transformations.
1. Expression Transformation
2. Aggregated transformation
3. Rank Transformation
Is This Answer Correct ? | 48 Yes | 3 No |
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
how much memory (size) occupied by a session at runtime
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
what is the process of target load planing?
How to partition the Session?
How can we store previous session logs?
how can one eliminate dupliacte data with out using distinct option?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
Explain sql transformation in script mode examples in informatica
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste