1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
- 10 Answers
- 12056 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / ankur saini
hey guys c if this works...
add an exp after source qualifier...with two more ports
v_out as variable =iif((is_number(inputport),0,v_out+1)
output=v_out
so output from this exp will be
1 0
2 0
3 0
* 1
....
* 2
...
now add a filter where output>0
Thanks
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
permutations of mapplet
What is informatica metadata and where is it stored?
What all are steps in up gradation of Informatica server?
What is an Integration service in Informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How many number of sessions can one group in batches?
What is the function of aggregator transformation?
What are the uses of etl tools?
During the running session, output files are created by informatica server. Enlist few of them.
EXL informatica Questions
What do you mean by enterprise data warehousing?
How do you load only null records into target? Explain through mapping flow.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
