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 would u estimate the size of Lookup transform data and index cache?

0 Answers  

Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com

1 Answers  

When do we analyze the tables?

0 Answers  

how to connect to a flatfile through ftp in informatica

1 Answers   TCS,

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

0 Answers  

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

0 Answers  

what types of repositories we can create in informatica? in real time in which type of repository we will work on?

2 Answers  

In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.

3 Answers   Accenture,

Explain the key challenges that you face while performing etl testing.

0 Answers  

How many types of transformations supported by sorted input?

0 Answers  

Eliminating of duplicate records without using dynamic lookups

4 Answers   IBM,

what is session partitioning?

0 Answers  

For more ETL Interview Questions Click Here
Categories