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

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

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  


from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

21 Answers   Deloitte,


Define filter transformation?

0 Answers  


What are the differences between oltp and olap?

0 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  






Why the workflow is failed after running two hours in informatica?

1 Answers   GE,


What is persistent lookup cache?

0 Answers  


I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,


what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,


What is the Hierarchy of DWH?

1 Answers  


what are cost based and rule based approaches and what is the difference?

1 Answers  


what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,


Categories