Answer Posted / raghava
data one;
input number 10.;
datalines;
10
11
12
13
14
15
16
17
18
19
20
;
run;
data two;
set one;
if mod(number,2)=0 Then A=number; else B=number;
/* number=mod(number);*/
run;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All 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.
What is the difference between a connected look up and unconnected lookup?
How does the aggregator transformation handle null values?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How do you load unique records into one target table and duplicate records into a different target table?
What is a joiner transformation?
can anyone explain me about retail domain project in informatica?
Is it possible to create multiple domains on a single Informatica server?
What is the scenario which compels informatica server to reject files?
How do you load first and last records into target table?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How do you handle two sessions in Informatica
What are the settings that you use to configure the joiner transformation?
What is meant by a domain?
What is the use of code page?