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

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

2 Answers
9175 Views
DELL, iGate, I also Faced
E-Mail Answers

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

disable caching in a lookup transformation?

1 Answers

How do you create single lookup transformation using multiple tables?

6 Answers TCS,

Can anyone tell me the new features in Informatica 9 Version?

2 Answers Syntel,

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers

Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers

What is target update override

2 Answers CTS,

when we go for unconnected lookup transformation? and why?

5 Answers Accenture,

why we use stored procedure transformation?

4 Answers IBM,

What are the different clients of powercenter?

0 Answers

What is difference between Mapplet and reusable transformation?

9 Answers Wipro,

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers Puma,

For more Informatica Interview Questions Click Here