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
- 8492 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / suresh
Use Sequence generator
In sequence generator set the properties
start value 1
end value 3
cycle yes
conn sequence generator to exp and test in router
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are the data movement modes in informatica?
What is the use of transformation?
What do you mean by blocking transformation?
tell me about your project functionality
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is informatica metadata and where is it stored?
How to open an older version of an object in the workspace?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Describe data concatenation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
hi real timers . iam waiting for ur reply regarding ETL TESTING
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the procedure for creating independent data marts from informatica 7.1?
What is a filter transformation?
