Interested to Buy Any Domain ? << Click Here >> for more details...
1) Alternative to update strategy transformation
2) out of 1000 records after loading 200 records, the
session got failed. how do u load the rest of records ??
3) use of lookup override
- 3 Answers
- 10537 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / mike
1)YOu can update the target table by using target update
override. I think this might be the alternative
2)consider performance recovery
3)lookup override is nothing but overriding the default sql
which is generated by the lookup at run time. the default
sql contains select,groupby and orderby clauses. The
orderby clause orders the data based on the ports in lookup
tab. If you want to change the order then we need to
mention two hyphens at the end of the sql, which means the
query generated by the informatica server is commented.
correct me if i was wrong
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a repository server and a powerhouse?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to Create a folder using pmrep command?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How can we store previous session logs?
Under which circumstances, informatica server creates reject files?
How to open an older version of an object in the workspace?
Enterprise data warehouse your projects phase by phase explain?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
In development project what is the process to follow for an etl developer from day1
can you please explain me pre session and post session options?
Briefly explain the aggregator transformation?
design of staging area?
While migrating the data from one environment to another environment how would you manage the connections?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
