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
9311 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

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

5 Answers TCS,

How will you combine 3 different sources with a single source?

3 Answers

How identifying bottlenecks in various components of informatica and resolving them?

0 Answers

Explain the features of connected and unconnected lookup.

0 Answers

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers IBM,

what is the Default Source Option For Update Strategy Transformation?

0 Answers Informatica,

in which situations do u go for starflake schema ?

6 Answers TCS,

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers IBM, TCS,

difference between informatica 8.6 and 9

3 Answers Atos Origin, BA Continnum Solutions, Core Logic,

What is a passive transformation?

0 Answers Informatica,

what are the output files that the informatica server creats during running a session?

2 Answers CTS,

How can you validate all mappings in the repository simultaneously?

0 Answers

For more Informatica Interview Questions Click Here