Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.1 2321
case 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 1452
scenario: 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 ABCDPQRS1 2722
How 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.
I 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 .
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
The question was on time stamp. what is the difference between HH and HH24 when to use when.1069
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.918
Explain your project of banking domian.807
What is native users?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explian the Process of deployment groups in informatica
What is the format of informatica objects in a repository?
How can you validate all mappings in the repository simultaneously?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the benefit of partitioning a session?
What is transformation?
what is the size of your data warehousing?
What is an active transformation?
Which transformation should we use to normalise the COBOL and relational sources?
Different circumstance which drives informatica server to expel records?
What is mapping debugger?
What is the session task and command task?