Interested to Buy Any Domain ? << Click Here >> for more details...
I have a scenario like - how can i load 1st record to
Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to
repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
- 3 Answers
- 9792 Views
- ITC Infotech, TCS, I also Faced
- E-Mail Answers
Answer Posted / susanta
Take a sequence generator with Start Value=1,Current
Value=1,End Value=3, Increment By=1 to assign a seqno to
each row. Do not forget to enable the cycle option.
after that take a Router with three groups of
seqno=1,seqno=2 and seqno=3.
Hope this will help u
| Is This Answer Correct ? | 28 Yes | 1 No |
Post New Answer View All Answers
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain pushdown optimization $pushdownconfig parameter - informatica
Briefly explain the aggregator transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
How many input parameters can exist in an unconnected lookup?
Explain in detail scd type 2 through mapping.
What are the differences between a connected lookup and unconnected lookup?
permutations of mapplet
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What do you understand by a term domain?
What are the different options available for update strategy?
what is the size of u r source(like file or table)?
When do you use sql override in a lookup transformation?
What is expression transformation?
What are the components of the workflow manager?
