Using Informatica Visio to generate mappings.
I am getting error "Table Definition Not Found Exception Error" while importing the template.
Answer / aa
Place the xml template in the MappingTemplate folder in ur C drive
u can refer more info below as well as Informatica KB
https://etltechsolutions.wordpress.com/2016/02/09/informatica-visio-table-definition-not-found-exception-error/
| Is This Answer Correct ? | 1 Yes | 1 No |
what is the logic will you implement to load data into a fact table from n dimension tables?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
What is the use of code page?
How do you recover rows from a failed session
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
what are the limitations of pushdown optimization technique ? Advance thanks
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
1 lac of flat fles in source how to load target at a time?
Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)