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 / psnadh

Answer Posted / psnadh

Hi,

In the source file if the row count is odd number,then how
can we check the condition to divide the ff into two halves?

If it is even,we can divide the ff into two halves as per
the above solutions.

Please give me reply how to implent that

Thanks in Advance

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1462

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

1404

What is dynamic cache?

610

What is source qualifier transformation in informatica?

571

Slowly changing dimensions, types and where will you use them

1270




explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1703

What is a passive transformation?

638

What is xml source qualifier transformation in informatica?

712

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?

1616

Differentiate between router and filter transformation?

613

How can you define user defied event?

616

Enterprise data warehouse your projects phase by phase explain?

1460

What is a filter transformation?

564

Explain how many types of dimensions are available in informatica?

593

How to Create a folder using pmrep command?

620