Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
1 3044case 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 1931scenario: 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 3787How 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 2899I 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 4086There 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 3930How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
1310Post New Informatica Questions
What are the features of complex mapping?
What are active transformations.
What are the tasks that can be performed using sq?
Can you generate sequence numbers without using the sequence generator transformation?
tell me 5 session failure in real time how can you solve that in your project?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Explain incremental aggregation in informatica
Explain how many types of dimensions are available in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
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
How you prepared reports for OLAP?
if we have a delimiters at unwanted places in a flat file how can we over come those.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explain the different lookup methods used in informatica?