Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 12857 Views
- DELL, TCS, I also Faced
- E-Mail Answers
Answer Posted / anu
take sequence generator connect neval port to router
in router create 3 groups
in 1st group (nextval<=100) or (nextval>300 and nextval<=400)
or (nextval>700 and nextval<=800)........trg1
in 2nd group (nextval>100 and nextval<=200) or (nextval>400
and nextval<=500) or (nextval>800 and nextval<=700)......trg2
in 3rd group (nextval>200 and nextval<=300) or (nextval>500
and nextval<=600) or (nextval>900 and nextval<=1000)......trg3
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to join three sources using joiner?
Mention some types of transformation?
How can you define user defied event?
What are the differences between joiner transformation and source qualifier transformation?
What are the different types of olap? Give an example?
What is an active transformation?
What are the different versions of informatica?
What is the function of union transformation?
How do you load unique records into one target table and duplicate records into a different target table?
whats the logic to load the lower level of granularity of data to fact table.
what is the complex transformation you used in informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Can you use flat files in Mapplets.
