Suppose i have 10000 records.First time i have to load 1 to
1000 records and second run i have load 1000 to 2000
records and third load i have to load 2000 to 3000 rows .How
will achieve
Answer Posted / nataraj
Hi sanajy.. thanks for ur reply... i dont want to load the
records into different files.... i need to load the same
file in different mapping runs...
Than you
Is This Answer Correct ? | 0 Yes | 0 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
What are the different transaction levels available in transaction control transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How to load the data from people soft hrm to people soft erm using informatica?
To import the flat file definition into the designer where should the flat file be placed?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
how many types of dimensions are available in informatica?
What are the popular informatica products?
Explain constraint based loading in informatica
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
draw informatica architecture 8.6 ?
What is incremental aggregation?