in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
Answer Posted / eswar
As Prakash said
ower write sq ("select *from <tableNmae> where rownum <=
10;")
Instead of using Aggregator its better if we use Router
Transformation, wherefrom we can route the rows to target
(s).
note: use two target table in which u want to load that two
records
====
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Define pmcmd command?
How to call shell scripts from informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
can u any challenge your project?
What is a joiner transformation and why it is an active one?
Make a note of the quantity vaults made in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain what is informatica metadata and where is it stored?
What is a standalone command task?
What do you mean by worklet?
What is the sequence generator transformation in informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How we can create indexes after completing the load process?