Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
1 3822case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,
1 2518scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
1 4531How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
CTS,
1 3627I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
CTS,
2 5016There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
L&T,
2 4932How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
1732Post New Informatica Questions
what is the -ve test case in your project.
What are the uses of etl tools?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a repository manager?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How does a rank transform differ from aggregator transform functions max and min?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
what is index?how it can work in informatica
What is the difference between Active and Passive transformation?
How many number of sessions can one group in batches?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is the need for an etl tool?
Write the prerequisite tasks to achieve the session partition?
How to open an older version of an object in the workspace?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?