Interested to Buy Any Domain ? << Click Here >> for more details...
following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?
- 7 Answers
- 10290 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / gangadhar
Hi suresh you are 50% current
sq-->expression-----> rooter----->t1
seqno/ ------t2
-------t3
drag the all columns to expression create one new column this column connect sequence generator connect NEXT VALUE
In sequence generator set the properties
start value 1
end value 3
cycle yes
later exp-->router connect hear create 3 groups
group1-NEXT VALUE=1
group2-NEXT VALUE=2
group3-NEXT VALUE=3
first group connect to T1
second group connect to t2
third group connect to t3
is 100% correct
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can we create a node as a gateway node and the same node can be assigned to a grid?
What do you mean by blocking transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Is it possible to define a single node as a Gateway node as well as worker node?
Can we get 1st record through Informatica(without sequence number).
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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Design time, run time. If you don't create parameter what will happen
what is the size of u r source(like file or table)?
What are the data movement modes in informatica?
What are the different versions of informatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Write the unconnected lookup syntax and how to return more than one column.
What is the difference between stop and abort in informatica
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
