Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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

Answers were Sorted based on User's Feedback



Hello all, Source Table(Flat File):- Target Table(Flat File):- Date ..

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

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date ..

Answer / bhagya

In expression transfromation
to_date(datecolumnname,dd/mm/yyyy) and pass this link upto
target

Is This Answer Correct ?    3 Yes 1 No

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date ..

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

Post New Answer

More ETL Interview Questions

How to increase performance without changing anything in mapping.( In prod)

0 Answers   IBM, Saama Tech, Wipro,

how many maximum session supports to multiload in teradata ??

0 Answers   IBM,

Can anyone explain me a scenario from banking and finance...more precisely a mapping

0 Answers   IBM,

What are snapshots?

0 Answers  

What are the different ways to deploy the code in informatica?

1 Answers   IBM, Saama Tech, Wipro,

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  

what are the different Reporting and ETL tools available in the market?

3 Answers  

What are your responsibilities as an etl tester?

0 Answers  

how do u set the size of block buffer?

1 Answers  

What is Data Vault???

0 Answers  

what is SMP AND MPP?

8 Answers  

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers  

For more ETL Interview Questions Click Here
Categories