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

What is the role of informatica in project ?Like i showed financial projects?

1 Answers Amdocs,

What are some examples of informatica etl programs?

0 Answers

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers CTS,

What is parameter file?

2 Answers

I have source like this 1:2;3. so i want to load the target as 123

4 Answers HP,

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers

major difference between normal loading and bulk loading?

6 Answers

Do you have knowledge in ralph kimball methodology

1 Answers

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers Cognizant, HP, TCS,

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers CSC, iNautix,

What is the default join that source qualifier provides?

3 Answers Informatica,

For more Informatica Interview Questions Click Here