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)

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.

Answer / srini

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

Answer / lokendra

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

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

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

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.

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.

Answer / shiva

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

Answer / mack

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

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

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

What is the function of aggregator transformation?

0 Answers  

can we use bulk loading when we use look in mapping

1 Answers   TCS,

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

what is plsql table?

2 Answers  

What is mapplet and a reusable transformation?

2 Answers  

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com

0 Answers  

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

1 Answers   Puma,