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

I have Flat file like the data, sal have 10,000. I want to
load the data in the same format as sal as 10,000. Can
anybody know the answer means please mail me.
Thanks in advance.. My mail id is chandranmca2007@gmail.com

Question Posted / chandranmca2007

Answers were Sorted based on User's Feedback



I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal ..

Answer / sagarreddy

HI,
in target table options we have thousand separator,hundred
separator ,.................other options also available
.............
check it plz go through it .................

Is This Answer Correct ?    4 Yes 1 No

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal ..

Answer / davankumar

to_char(10000,'99,999.00') from dual;

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

What is enterprise data warehousing?

0 Answers  

What is the use of transformation?

0 Answers  

Which will beter perform IIf or decode?

3 Answers   TCS,

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

What is the maplet?

0 Answers   Informatica,




I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

Global and Local shortcuts. Advantages.

0 Answers  

How i can upload the MainFrame source For Informatica ?

1 Answers  

write a query row to column follwing source? quarter sales q1 5000 q1 9000 q1 7000 q1 6000 q2 5000 q2 4000 q2 3000 q2 1000 q3 4000 q3 3000 q3 1000 q3 2000 q4 5000 q4 400 i want the output? q1 q2 q3 q4 sales

3 Answers   Cognizant, Flextronics,

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories