1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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.

Question Posted / romi

Answer Posted / romi

Thanks to all,

But i want to store first half data in 1 table and another
half in another table. and with procedure i m getting
alternative data.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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.

2329

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?

555

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

1760

What is the difference between STOP and ABORT options in Workflow Monitor?

699

How will the document be delivered to me?

621




How to load the data from people soft hrm to people soft erm using informatica?

566

How you know when to use a static cache and dynamic cache in lookup transformation?

1345

Mention few advantages of router transformation over filter transformation.

642

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1626

Explain the different lookup methods used in informatica?

593

What are the data movement modes in informatica?

707

What is a code page?

721

Explain pmcmd command usage in informatica

711

What is DR strategy for Informatica project?

708

Under what condition selecting sorted input in aggregator may fail the session?

669