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.




Answers were Sorted based on User's Feedback



for ex: in source 10 records are there with column sal. use a filter transformation condition as S..

Answer / krishna

I checked result.

Case 1: when you use filter condition sal=true

nothing will be moved to target table. session succeeded
but no data in target table.

Case 2: when you use only TRUE as filter condition.

all 10 records from source passes through filter to target
table .(in target table also we will get 10 records)

Is This Answer Correct ?    31 Yes 0 No

for ex: in source 10 records are there with column sal. use a filter transformation condition as S..

Answer / pushpa

by default filter condition has the TRUE that means don't
worry whether the incoming data numeric or string.all incoming
data passed to the next transformation or target.
if we assign a condition manually sal=True.session is executed
successfully but even single record is not loaded into the
target.

Is This Answer Correct ?    19 Yes 0 No

for ex: in source 10 records are there with column sal. use a filter transformation condition as S..

Answer / srini

Answers 1 and 4 right. Since the session will be executed
successfully but no rows will be loaded into the target.

Is This Answer Correct ?    15 Yes 0 No




for ex: in source 10 records are there with column sal. use a filter transformation condition as S..

Answer / lokendra

if 'salary= true' ,no records will come to target.

if only 'true' it will pass all the 10 records.

Is This Answer Correct ?    8 Yes 0 No

for ex: in source 10 records are there with column sal. use a filter transformation condition as S..

Answer / arvind s

Sorry guys, Answer 3 is completely wrong.

TRUE is not identified as a string by informatica, its
represented as a bit, just like a high or low, (1 or 0)
almost equivalent to a boolean.

So we can equate sal=TRUE but sal='TRUE' will result in
invalid mapping as said in answer3.

Thanks,
Arvind S

Is This Answer Correct ?    6 Yes 0 No

for ex: in source 10 records are there with column sal. use a filter transformation condition as S..

Answer / pradeepa

Hi,

If the comparing column is a varchar and if this true is
given in single quotes it will validate ,but here salary
for sure it must be a number and when we say salary=true it
will trow error,that expression wont be validated..

obviously mapping will get invalidated..so we cant evn run
the ,mapping.

Is This Answer Correct ?    2 Yes 0 No

for ex: in source 10 records are there with column sal. use a filter transformation condition as S..

Answer / shiva

nothing will happen when we use filter option it just check
the source record where all record are salary records or nor

Is This Answer Correct ?    2 Yes 2 No

for ex: in source 10 records are there with column sal. use a filter transformation condition as S..

Answer / venkat

hi guys ans 3 totally wrong
see this,
1)suppose u given condition like sal=true ,the session will
successfully execute but no data load in to target.
2)suppose u given condition like sal='true' it's not
validated b'coz in filter true/false like 1/0.
3)suppose u given condition like onlt true ,the session will
successfully execute and all the data also loaded in to target.

Is This Answer Correct ?    0 Yes 0 No

for ex: in source 10 records are there with column sal. use a filter transformation condition as S..

Answer / mack

Answer 3 is correct. Whenever you trying to validate your
expression ,it will give you an error.

Is This Answer Correct ?    2 Yes 4 No

for ex: in source 10 records are there with column sal. use a filter transformation condition as S..

Answer / amit

it gives expression error because we used sal=true
expresssion insted of sal='any numeric value i.e. we have
to define numeric value in the expression

Is This Answer Correct ?    5 Yes 10 No

Post New Answer



More Informatica Interview Questions

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,


Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  


what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  


what are surrogate keys?

5 Answers  


What is the functionality of update strategy?

2 Answers  






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.

0 Answers   IBM,


can any one explain me about junk dimension

4 Answers  


Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,


What is hash partition?

2 Answers  


my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,


in which situations do u go for sequence generator ?

2 Answers   TCS,


i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,






Categories