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 >> Informatica
  2. Suggest New Category

My flat file source is
C_Id 1-nov-2011 8-nov-2011
100 2000 1500
101 2500 2000
I want my Target as
C_Id Week_Num Amt
100 45 2000
100 46 1500
101 45 2500
101 46 2000

Question Posted / rakeshm4119

Answers were Sorted based on User's Feedback



My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I w..

Answer / vijaya

by using normalizer transformation we can done it.

sq-> ex,-> norm-> tgt

if you want clear answer u check tmrw this question

Is This Answer Correct ?    4 Yes 0 No

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I w..

Answer / rakesh

Thanks Vijaya.
In Expression we can use the date function to find the week number of the year. But here we have 1-nov-2011 as the column name, but not the column value. i.e; we have dates as column names, not as col values..
So please clarify..

Is This Answer Correct ?    2 Yes 0 No

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I w..

Answer / yamini

Hi,

we can pass the date values in mapping parameter. why because as the column values are constant so we can pass that values in expression by creating output ports.

So after exp transformation put a normalizer with occurrence 2. after normalizer put an exp to convert date into week by to_char function

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

What is the target load order?

3 Answers   HCL, Informatica,

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

How to update records in Target, without using Update Strategy?

3 Answers  

where to select code page option?

2 Answers   TCS,

Explain why we use partitioning the session in informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories