Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
Answer / isha
Among these three, you can only use seq generator (only reusable sequence generator)
| Is This Answer Correct ? | 0 Yes | 0 No |
when we dont use aggregator in mapping ?
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
In which scenario did u used Mapping variable?
Can you use flat files in Mapplets.
How to prepared lld.can any one tell me detailed explanetion.
what is flat file override?
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.
How the dimensions will be loaded?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?