What are differences between Informatica 7.1 and 6.1
Answers were Sorted based on User's Feedback
Answer / rishikesh
lookup on flat file in informatica7.1
no such provision in 6.1
union all trnasformation in 7.1 not in 6.1
transaction control tranformation not in 6.1
file reposioty in 7.1
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sanjay
Except to previous points.........
1. PMCMD: By using this option we can use parameter file at
command prompt. Why this needed suppose we are using more
than on parameter file, in such case we have to change the
parameter file in session properties. By this option u can
run from command prompt by changing parameter file, no need
to go to session properties.
2. Test load: we can test the load by taking the specified
no. of records.
| Is This Answer Correct ? | 0 Yes | 1 No |
can we create index and drop index in exsisting table while using infomatica
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
Mention some types of transformation?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
If a table contains 100 records we have to fetch 50-100 records from source to target?how
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
when we dont use aggregator in mapping ?
If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
What is the difference between lookup override and souce qualifier override ?
Why we use partitioning the session in informatica?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.