Interested to Buy Any Domain ? << Click Here >> for more details...
If one flat file contains n number of records., we have to
load the records in target from 51 to 100.. how to use
expressions in Informatica..?
- 6 Answers
- 15816 Views
- I also Faced
- E-Mail Answers
Answer Posted / gurava reddy
Source-SQ-SEQ-FILTER-TARGET
1.Connect the sequence genarater(NEXTVAL) to filter in filter
IIF(NEXTVAL>=50 and NEXTVAL>=100,TRUE, FALSE)
2. Then connect the ports to destination(Target)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain scd type 3 through mapping.
How union transformation is used?
whats the logic to load the lower level of granularity of data to fact table.
Performance tuning( what you did in performance tuning)
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a pre-defined event and user-defined event?
What are the different transaction levels available in transaction control transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is main use of mapplet?
Is it possible to define a single node as a Gateway node as well as worker node?
how we can load rejected record's at run time?(not through bad files)
Why do we need informatica?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Please let me know how to make Data masking in informatica..
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
