What happens to map if we alter the datatypes between source and its corresponding source qualifier?
No Answer is Posted For this Question
Be the First to Post Answer
What is partioning?how many types of partinings are there
What is dynamic cache?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
what is the process we used in joiner transformation,there is no matching column in sources?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
What are the mapings that we use for slowly changing dimension table?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
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
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is a look up function? What is default transformation for the look up function?
differences between service based and product based?