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

two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.

0 Answers  

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers   CTS,

Eliminating of duplicate records without using dynamic lookups

1 Answers  

how do u identify the changed records in operational data?

0 Answers   QualTech,

Explain different types of partitioning?

0 Answers  

What are materialized views & where do we use them?

0 Answers  

What is data modeling and data mining?

0 Answers  

explain the methodology of Data Warehousing?(Polaries)

0 Answers  

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

0 Answers   Cap Gemini,

what are the concerns of OLTP and DSS systems?

0 Answers   TCS,

Can u access a repository created in previous version of Informatica?

1 Answers   DELL,

What is tracing level? How many types of transformations supported by sorted input?

0 Answers  

For more ETL Interview Questions Click Here
Categories