1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
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
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the differences between oltp and olap?
What is the difference between a connected look up and unconnected lookup?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is an Integration service in Informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the mapping parameters and mapping variables?
What are multi-group transformations?
What does refresh system mean, and what are its distinctive choice?
How might one distinguish in the case of mapping is right or not without associating session?
How to implement security measures using repository manager?
What is session task and command task?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the types of caches in lookup? Explain them.