Interested to Buy Any Domain ? << Click Here >> for more details...
What are limitations of joiner transformation?
- 2 Answers
- 21102 Views
- Exilant, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / seshagiri k
1.Both the pipelines begin with the same original data spouece
2.Both input pipelines originate from the SQ transformation
3.Both input pipelines originate from the same normalizer t/r
4.Either input pipelines contains an update transformation
5.Either input pipelines contains a connected or unconnected
sequence generator transformation
| Is This Answer Correct ? | 14 Yes | 5 No |
Answer / maruthi
JOINER,AS IT JOINS DATA FROM HETROGENOUS SOURCES
1)STRUCTURE OF THE BOTH TABLES SHOULD BE SAME.(V.IMP)
ANYWHERE SAY IT FIRST
| Is This Answer Correct ? | 2 Yes | 34 No |
how to identify new and old values in source qualifier or any other transformations using informatica
What are the restrictions of union transformation?
Which is the best place to learn Informatica Powercenter Online Training?
Can any one explain or sujjest some sites for scd mappings.Thank you
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are teh different tasks that can be created in workflow manager?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
what is informatica metadata?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Teradata 
