Interested to Buy Any Domain ? << Click Here >> for more details...
can we use cartesian join in informatica
- 3 Answers
- 8434 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh
yes we can ,by creating dummy ports in expression transmission like forjoin and tojoin ,in joiner transformation condition is forjoin=tojoin and output is m*n format
| Is This Answer Correct ? | 1 Yes | 0 No |
we can use Cartesian join in informatica by using full outer
option in joiner t/r
if am wrong please let me know
| Is This Answer Correct ? | 1 Yes | 10 No |
What are teh different tasks that can be created in workflow manager?
how do u fnd the duplicate rows and how to delete the duplicate rows?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
How do you change a non-reusable transformation to reusable transformation?
How many types of sessions are there in informatica.please explain them?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
how to we create datamart?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the data movement modes in informatcia?
Teradata 
