i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?
eno , ename, sal
header :DDMMYYYY24MMSS timestamp
how to implement the same in a FF tgt?
i have a table with name field.
nitikripa so no
if a occures 3 times in name then it will go to tgt A
if b occures 3 times in name then it will go to tgt b
if z occures 3 times in name then it will go to tgt z
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG
I need to get max date and its corresponding flag for both the date columns.
I have 100 million + in the table so avoid self-join...
I need the output file in the below format using Informatica.
6 1 3 1 5 1 6 1 10 1 6 10
Pos State Time Split AgentID Reason Spaces
Code in Code Spare
______ ___ _____ ______ __________ ______
1234 14 0 4321 3103 abcd
4321 15 5 123452 3150
Can someone help please??
We need the data in space-delimited, fixed ASCII format .
Slowly changing dimensions, types and where will you use them
what is song in infrmatica...?
In which scenario did u used Mapping variable?
can u any challenge your project?
can anybody send me some real time screenshots of mapping in
i will be vary thankful to him.
my e-mail id :- email@example.com
waht type of interface is used for testing the data in
lookup transformation with screenshots
explain one complex mapping with logic? sales project?
tell me 5 session failure in real time how can you solve
that in your project?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
what is mean by complex business rule ?
What is the main purpose of Unconnected lookup other than
updating slowly changing dimensions?
or In which case u use Unconnected lookup?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.