Interested to Buy Any Domain ? << Click Here >> for more details...
we have table like cust_id,cust_name,cust_loc like this
1.we need to get perticular location,to do this we can use
filter transformatin,that logic is same for relation table
and flat file tabl?
- 2 Answers
- 6175 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rahul
You can write the SQL statement for that particular
location in the source qualifier if it is a relational
table.
Use Filter if it is a flat file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sreenu
yes
but if it is a relational table beter to use SQL overried
for performence
for flat files u have to use filter t/r
| Is This Answer Correct ? | 1 Yes | 1 No |
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
what is the exact meaning of domain?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
What is the advantage of persistent cache? When it should be used.
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
What are differences between Informatica 7.1 and 6.1
SO many times i saw "$PM parser error " .what is meant by PM?
What are the types of lookup transformation?
Explain how many types of dimensions are available in informatica?
How many mapplets u have created? and what is the logic used
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Teradata 
