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
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 |
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.
How will you combine 3 different sources with a single source?
How identifying bottlenecks in various components of informatica and resolving them?
Explain the features of connected and unconnected lookup.
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?
what is the Default Source Option For Update Strategy Transformation?
in which situations do u go for starflake schema ?
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
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
What is a passive transformation?
what are the output files that the informatica server creats during running a session?
How can you validate all mappings in the repository simultaneously?