Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - In source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target? what will happen?




2531
views
asked marvit January 5, 2015 01:47 AM  

In source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target? what will happen?


           

3 Answers



 
answered By Beginner   0  
This answer is pending moderator approval session will execute but no records will get loaded as no the condition is false.
flag   
   add comment

 
answered By Sourav   0  

If the SAL is numeric the records will be compare with TRUE as 1 and all records get dropped. if its strin it will be comapared with TRUE and will get dropped, so no records get loaded in target.

flag   
   add comment

 
answered By pavan850   0  

Records are loaded to target...like pass through mapping..if u put false manually then no records load to the target..

..IF U PUT PARTICULARLY SAL=TRUE THEN NO DATA LOADED TO TARGET...

flag   
   add comment

 
answered By vishnoiprem   0  
  • if we assign a condition manually sal  is True.
  • session is executed successfully but no  record is being loaded into the target
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  2 people following this question

  2 people following this tag

  Question tags

informatica × 1

Asked 3 years and 5 months ago ago
Number of Views -2531
Number of Answers -3
Last updated
2 years and 3 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert