I Have 100 Records in a relational tble and i want to load
the record in 3 targets , first records goes to target 1
and second to target 2 and third to target 3 and so
on ,what are the tx used in this and what are the
logics ,can any one help me ?? Thanks in Advance
Answer Posted / im
Using Constraint Based Loading option in SQ T/r......
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How does a rank transform differ from aggregator transform functions max and min?
have u done any performance tuning? how u ll do?
How can one identify whether mapping is correct or not without connecting session?
what is index?how it can work in informatica
Explain the features of connected and unconnected lookup.
Write the program through which the records can be updated?
Why do you use Mapping Parameter and mapping variable?
Explain the informatica workflow?
How you know when to use a static cache and dynamic cache in lookup transformation?
Clarify the aggregator change?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to handle decimal places while importing a flatfile into informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?