The simplest thing U can do is while importing the source flatfile using

Hello all,

Source Table(Flat File):- Target Table(Flat File):-

Date Date

01/08/2008(DD/MM/YYYY) 01/08/2008
02/08/2008
03/08/2008
04/08/2008
05/05/2008

My requiremnt is this. I need to do it by informatica,Plz
tell me how can i do it?

Thanks

Question Posted / kal

3 Answers
7054 Views
I also Faced
E-Mail Answers

Answer Posted / kal

The simplest thing U can do is

while importing the source flatfile using "Flat File Import
Wizard"
In Step1 choose-> FixedWidth
in the step2 -> click and create a column or tab on the
field then U can import them as 2 fields
1. 01/08/2008
2.(DD/MM/YYYY)

U can ignore the second column and use the first one.

second method is by taking only the date value in
Expression Transformation.

Hope this of any help

Kal

Is This Answer Correct ?

4 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the production issues in datastage?

10311

What are materialized views & where do we use them?

917

what are Lookup caches options? Including persistent caches.

1895

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1719

Explain what is etl process? How many steps etl contains explain with example?

831

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

2061

What are the ETL Testing Operations?

987

What is etl process. How many steps etl contains explain with example?

896

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1672

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2433

Can there be sub steps of etl steps?

940

Give the benefits of data integration suite?

867

Explain about enterprise scalability and roi of data integration suite?

833

What is etl process?

875

Explain about etl data integration software?

843