In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
2016Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
TCS,
1 3700what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
TCS,
2 4202How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
2 14975Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
2 6676Post New Informatica Questions
what is informatica metadata?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the informatica performance improvement tips
Where do we use mapping variables in informatica?
What is the benefit of partitioning a session?
what is the difference between informatica6.1 and infomatica7.1
What are the static cache and dynamic cache in informatica?
can anyone suggest best free Talend data integration training online
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what is the hint? how to use it to reduce the query processing in program?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are the types of caches in lookup? Explain them.
What are the steps involved in the migration from older version to newer version of Informatica Server?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Define filter transformation?