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
Answers were Sorted based on User's Feedback
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 |
Answer / kuttu
if you require only 5 rows in the target we can use 5
target aliases and acheive it.
Is This Answer Correct ? | 0 Yes | 1 No |
What is cube grouping?
Do we need an etl tool?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
how many steps are there in etl process?
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
What are the different etl testing categories as per their function?
What is meant by incremental load?
What are dimensions?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
What are the names of the layers in etl?
what is Forward,Reverse and Re_engineering?