-
How to read the data from XML and flat files in informatica?
MAHESH MANAM
- Aug 16th, 2012
From flat file you use the following wys: --> In source analyzer you can create file by manually -->you can import file -->you can use any of the flat file and give session properties in that correc...
dileep671
- Aug 3rd, 2012
Go to Source analyzer , then import XML Source, a wizard opens up.. select the Schema Definition (XSD) of th XML file
When you run the session, give the XML file name and XML file directory path. -
Typical Scenario - Schedule
Please help to set up following scenarioI have a source either file or db tableEno ename sal dept101 sri 100 1102 seeta 200 2103 lax 300 3104 ravam 76 1105 soorp 120 2Want to run a session 3 times.First time: it should populate dept 1Second time: dept 2 onlyThird time: dept 3 onlyHow can we do this?
MAHESH MANAM
- Sep 27th, 2012
We can solve this issue by the following types: First, we can create a mapping parameter and run the mapping in each time give the parameter value according to your requirement. Second, we can creat...
dileep671
- Jul 25th, 2012
Put this query in Source Qualifier select empno, ename, sal, deptno from emp_src where deptno not in (select deptno from emp_trg); Then connect it to Rank Transformation In the properties, Select To...
