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

Why do we use DSS database for OLAP tools?

2 Answers

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers

What is hash partition?

1 Answers

What are the mapings that we use for slowly changing dimension table?

2 Answers

What is joiner change?

0 Answers

I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers

How will the document be delivered to me?

0 Answers

without using emailtask how will send a mail from informatica?

3 Answers

Is there any target staging area in informatica not staging area

0 Answers Syntel,

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers CTS,

I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000

4 Answers HCL,

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers

For more Informatica Interview Questions Click Here