Hi experts ,I have a Source of 1000 records.I have to load
100 records in first target,101 to 200 records in 2nd
target, 201 to 300 records in 3rd target and again 301 to
400 in first target like that as cyclick process. How can i
acheive this.
Answer Posted / ramana sreepathi
Take sequence generator connect nextval port to router
in router create 2 groups
in 1st group (TRUNC(nextval, -2) mod 200 = 0) or (TRUNC
((nextval – 1), -2) mod 200 = 0) ..... trg2
in 2nd group (TRUNC(nextval, -3) mod 300 = 0) or (TRUNC
((nextval – 1), -3) mod 200 = 0) ... trg3
in default group
trg3
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the types of schemas we have in data warehouse and what are the difference between them?
What do you understand by a term domain?
what is SDLC way of code development?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Define update strategy?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is main use of mapplet?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is the sql query overwrite in source qualifier in informatica
Explain the features of connected and unconnected lookup.
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Differences between version 7.x and 8.x.
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?