Interested to Buy Any Domain ? << Click Here >> for more details...
hi all, i have 1 flat file having 10 rows. like:-
id name amt
100 a 100
200 b 200
100 n 300
400 p 3000
100 a 100
600 x 6000
Now i want to load half of this data into one flat file and
remaining in other flat file.like :-
flat file 1
id name amt
100 a 100
200 b 200
100 n 300
----------------------
----------------------
flat file 2
id name amt
400 p 3000
100 a 100
600 x 6000
Plz reply me ASAP.
- 10 Answers
- 16843 Views
- I also Faced
- E-Mail Answers
Answer Posted / bala ramesh
in this logic , frist take one sequene genrator
transformation ,pass next value to expression
transformation and also pass id,name,and amt.
in this transformation and also create one output port
(temp).it is decimat type and write codition like
(iif(NEXTVAL %2=0,0,1)) , after take one router
transformation ,pass these ports (id,name,amt and
temp) .then create two group ,one is temp=0 and another one
is temp=1.after pass first group to one flat file ,second
group to second flat file.
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is a standalone command task?
Define update strategy?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Explain dynamic target flat file name generation in informatica
What is the use of source qualifier?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is parallel processing in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
What is the function of look up transformation?
Explain the tuning lookup transformation - informatica
Separate from an archive server and a powerhouse?
Differentiate between Load Manager and DTM?
without table how to come first record only in oracle?
What is meant by LDAP users?
