Interested to Buy Any Domain ? << Click Here >> for more details...
What are the circumstances that infromatica server results
an unreciverable session?
- 1 Answers
- 5122 Views
- I also Faced
- E-Mail Answers
Answer / swetha
The source qualifier transformation does not use sorted ports.
If you change the partition information after the initial
session fails.
Perform recovery is disabled in the informatica server
configuration.
If the sources or targets changes after initial session fails.
If the maping consists of sequence generator or normalizer
transformation.
If a concuurent batche contains multiple failed sessions.
| Is This Answer Correct ? | 2 Yes | 0 No |
How do you take back up of repository?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
To achieve the session partition what r the necessary tasks u have to do?
What is update strategy transform?
I want load the data into target with out 1st and last record.
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
How can we use batches?
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
What are the differences between source qualifier and joiner transformation?
Explain the etl program with few examples.
explain abt joiner t/r?
Teradata 
