Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
1 3826case 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 2521scenario: 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 4533How 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 3632I 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 5018There 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 4936How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
1734Post New Informatica Questions
How do you migrate data from one environment to another?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How many transformations can be used in mapplets.
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Which transformation is needed while using the Cobol sources as source definitions?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Explain Dataware house architecture .how data flow from intial to end?
Implementation methodology
What is target designer and target load order?
generate date / time dimension in informatica
What is a node in Informatica?
What is workflow manager?
What is the sql query overwrite in source qualifier in informatica