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
- 3 Answers
- 6643 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
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
What is etl process? How many steps etl contains?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
Explain different types of partitioning?
What is the difference between project backlog and product backlog?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is a staging area? What is the purpose of a staging area?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how to load the data to fact table?
When do we analyze the tables? How do we do it?
Is apache nifi an etl tool?
What is the difference between Data Warehousing and Data Mining?
what is data modeling?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
