Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 11 Answers
- 22796 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 ? | 1 Yes | 0 No |
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 |
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 |
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 |
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
How can we update a record in the target table without using update strategy?
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?
explan ur project architecture?
What is IQD file?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Can we create multiple integration service on single repository?
hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.
What is aggregate cache in aggregator transformation?
How to extract original records at one target & Duplicate records at one target?
What is power center repository?
Teradata 
