![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions What r the defferent types of dimension tables?how can we join the table if they have no matching point and related keys? Read Answers (5) | Asked by : kishore Can anyone help me if i add a column in my flatfile source how can load to the target which already contains data. What is the difference between using Joiner and Using Lookup to join to tables. Which is good to use. Read Answers (5) | Asked by : Naveen Kumar 2 tables are present on 2 oracle databases, How to join those 2 tables? Which transformtion should be used? Read Answers (6) | Asked by : mahendra How to recognize zero records in source flat file?I read a flatfile and I should ABORT () if there are no incoming records. How I can do this? The source file is on Unix, so I could use shell scripts, but I would to do this in Informatica....Another questions:can I use Unix pipe as input ("flat")file? A fast method to determine which record I'm processing now? i.e. in the 5th record of the flat file I have to do something special, how to find out this record? ThanksSergej Read Answers (1) | Asked by : Sergej how to join the data of two tables which do not have common columni mean how to perform non equi join in informaticaEg:just like getting data from emp and salgrade table of oracle where sal is between Latest Answer : Hi,The best way to join data from two tables which donot have common columns is first use a sequence generator transformation to generate the keys,then connect it to an expression transformation and then use a joiner transformation to join the tables.I ... Can we use LEFT OUTER JOIN (ANSI SQL standard) in SQ query override with SAMPLE key word?(help me my Can we use LEFT OUTER JOIN (ANSI SQL standard) in SQ query override with SAMPLE key word?(help me my dba used same in a mapping which have 5 rel SRCS from a single db and contain expression -- directed to TGT) Read Answers (3) | Asked by : N SRIRAM How to retrieve only distinct record from 'flatfile' source, without using sorter transformation? Is it posible? How? HP Interview Question View Question | Asked by : bunty View Question | Asked by : bunty question was asked from accenture and Wipro. Latest Answer : U hav to create a dummy common column in both tables thn u can join both tables. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||