1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
Answer Posted / guest
u can use mapping variable in exp transformation.
and do
decode(v_curr='*' or v_prev='*',setvariable($$,$$+1),$$)
and last port in exp setvariable($$,0) and accrdingly filter the non required...
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain transaction control transformation in informatica
How can you validate all mappings in the repository simultaneously?
How would you join a node to the already existing domain?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the sql query overwrite in source qualifier in informatica
Explain incremental aggregation in informatica
How to improve the performance of a session using sorter transformation?
Explain why we use partitioning the session in informatica?
r u done any partitions in ur project?
What are the conditions needed to improve the performance of informatica aggregator transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to load the data from people soft hrm to people soft erm using informatica?
What are the differences between oltp and olap?
What do mean by local and global repository?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?